<?php
	$json=array();
	$dbuser='root';
	$dbpassword='';
	$dbdatabase='jm24';
	
	$pdo=new PDO("mysql:host=localhost;port=3307;dbname={$dbdatabase}","{$dbuser}","{$dbpassword}");
	$pdo->exec('set names utf8');
	
	$file=fopen("1.txt","r");
	while(!feof($file)){
		$line=fgets($file);
		$strList=explode("\t",$line);
		$strList[1]=substr($strList[1],0,8);
		$pdo->exec("INSERT INTO tb_24_expressions VALUES({$strList[1]},'{$strList[0]}')");
	}
?>
 